<?php
/* wwwschool project

Copyright (C) 2009  Phillip Aldridge
Email : info@imi21.com
Web site http://www.imi21.com

This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
*/


/**
 *  File : toggle.php
 *  called only via ajax 
 *  
 *  requires POST  f, id
 *  the div element is 't+id' 
 */  

//$$TODO Who is allowed to edit this

$html="";
$message="";
$active="";
$db=new WS3_Database();
$dbSelect=new WS3_Database();
$id=$db->makeSafeInt($id);
$f=$db->makeSafeString($f);

$q="UPDATE `$f` SET active= NOT(active) WHERE `id`= '$id' LIMIT 1";
if ($db->query($q))
{
  $q="SELECT `active` FROM `$f` WHERE 1 AND `id`= '$id' LIMIT 1";

  if ($dbSelect->query($q) && $dbSelect->nextRecord() )
  {
    ($dbSelect->f('active') == '1')? $active = '1': $active = '0';
    $html="<a href=\"javascript:void(0)\" onclick=\'ajaxToggle(\"f=$f&amp;id=$id\")\'><img src=\"".WS3_TEMPLATE."images/active-".$active.".png\" alt=\"d\" /></a>";
  }
  $message="Changed";
}else
{
   $message="Error : ID not found";
}

echo "document.getElementById('messages').innerHTML='$message';";
echo "document.getElementById('t$id').innerHTML = '$html';";

if (W3DEBUG) $debug=new WS3_Debug();
?>
